2017-06-22 - 42819 - Service Request - COPA report field validation #CrystalReportsSupport
Service Request
42819 - COPA Report field validation
Problem Summary
Need to validate COPA reports with BEx query for CG8 & CG9.
Admin Info
Purpose
|
Need to validate COPA reports with BEx query for CG8 & CG9.
|
Requested by
|
Saravanan Lakshmanan
|
Issue Date
|
06-22-2017
|
Resolved by
|
Dhananjay G
|
Resolved Date
|
06-27-2017
|
Document Status
|
Complete
|
Detailed Problem Description
Email from Saravanan Lakshmanan on 06/22/2017:
Here are a list of errors in the data we are currently receiving:
1. CUSTOMER -Still using customer groups for US instead of only regions.
2. CUSTOMER - Still receiving customer group 9 data for Mexico and Japan instead of Customer group 8.
3. SEASON - Still receiving collections instead of only Custom, Stock and Program.
4. LICENSE - Still receiving license consolidations(everything should come over on the exact license it belongs to).
Solution Analysis and Recommendations
1. Need to check if requested changes are available in 7 COPA reports.
2. Need to create temp query in BW and to add CG9 field.
3. Need to analyze Customer logic in the reports.
4. Need to analyze Season logic in the reports.
5. Need to check License filed in the reports.
6. Need to validate the data with BEx queries in the reports.
7. Need to combine all the COPA report files into one excel file and provide to NEC.
Resolution
1. Created new query ZMP_OPASA_BPC_TEMP and used in all reports for getting CG9 field.
2. Created two formulas for CG8 & CG9 in all 7 COPA reports. They are:
Customer Group 8:
IF {ZCOPA_CO3_ZCOPA_CO3_BPC.[0SALESORG]-[20SALESORG]} IN ['1500','3200'] THEN
{ZCOPA_CO3_ZCOPA_CO3_BPC.[0CUSTOMER
ZCUST_GR8]-[20CUSTOMERZCUST_GR8]}
Customer Group 9:
IF NOT({ZCOPA_CO3_ZCOPA_CO3_BPC.[0SALESORG]-[20SALESORG]} IN ['1500','3200']) THEN
{ZCOPA_CO3_ZCOPA_CO3_BPC.[0CUSTOMER
ZCUST_GR9]-[20CUSTOMERZCUST_GR9]}
3. Updated Season formula for the following conditions:
if {ZCOPA_CO3_ZCOPA_CO3_BPC.[0AF_SEAN
ZBPC_SEA]-[20AF_SEANZBPC_SEA]} = 'CUSTM' then 'CUSTM'
else if {ZCOPA_CO3_ZCOPA_CO3_BPC.[0AF_SEAN
ZBPC_SEA]-[20AF_SEANZBPC_SEA]} = 'PRGRM' then 'PRGRM'
else if {ZCOPA_CO3_ZCOPA_CO3_BPC.[0AF_SEAN
ZBPC_SEA]-[20AF_SEANZBPC_SEA]} = '' then 'OTHERS'
ELSE 'STOCK'.
4. Generalized License filed used in all COPA reports.
5. Validated the data with BEx queries in the reports.
6. Placed the Season Group formula instead of Collection Group in all the COPA reports.
7. Provided NEC for the updated COPA reports Combined Spreadsheet for the period 05 2017.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Release Information
None